SELECT FORMSON_0999.FORMMAIN_ID "ID", FORMSON_0999.FIELD0012 assetNo,FORMSON_0999.FIELD0008 assetName FROM COL_SUMMARY
LEFT JOIN FORMSON_0999 ON FORMSON_0999.FORMMAIN_ID = COL_SUMMARY.FORM_RECORDID
WHERE COL_SUMMARY."ID" = '${id}'